Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 31

Which of the following tool you will use in Excel to see what must be the value of a cell to get required result?

a) Formula Auditing

b) Research

c) Track Change

d) Goal Seek

e) None of these

Question : 32

What happens if you remove the check mark from Row & Column headers on Options dialog box?

a) This will remove row headings and column headings of your data

b) This will remove the column headings (A, B, C)

c) This will remove row and column heading of chart

d) This will remove row and column heading of table

e) None of these

Question : 33

You can select a single range of cells by

a) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b) Pressing the Ctrl key while dragging over the desired cells

c) Pressing the Shift key and an arrow key

d) Dragging over the desired cells Correct

e) None of these

Question : 34

To create a formula, you can use:

a) Values but not cell references

b) Cell references but not values

c) Values or cell references although not both at the same time

d) Value and cell references

e) None of these

Question : 35

Without using the mouse or the arrow keys, what is the fastest way of getting to cell Al in a spreadsheet?

a) Press Ctrl +Home

b) Press Home

c) Press Shift + Home

d) Press Alt + Home

e) None of these